[Auth_Admin]

[Lasso_Comment]


	When recreating Lasso security settings for a server I found it very
	useful to get a quick overview of all database and user security
	settings, instead of struggling around in the extremely confusing Lasso
	Security interface.
	
	I haven't seen if anyone else have posted any examples or tips about
	cooking your own Lasso security, but I thought I could share what I've
	come up with.
	
	This file will give an overview of security settings per database and
	per user. See it as a beginning to use as is or to build on if you want
	to explore this further.
	
	Note: The first tag in the file is [Auth_Admin], which is a tag that was
	introduced in 3.6.6 to provide proper authentication of the file. For
	previous version you should make sure you protect access to this file by
	some other means. 


[/Lasso_Comment]

<HTML>
<HEAD>
<TITLE>Lasso Security Overview</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
	
	<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" bgcolor="#999999"> 
	<TR>
	<TD>
		
		<TABLE  BORDER="0" CELLPADDING="4" CELLSPACING="1">
		[inline:
			-database='LassoSecurity',
			-findall]
					
			[records]
				[if: (field: 'DatabaseName', EncodeNone) != 'LassoSecurity') 
					&& (field: 'DatabaseName', EncodeNone) != 'LassoUsers']
					
					<TR>
						<TD colspan=3 bgcolor="#ffffff" height=30 valign=bottom>
							<b>[field: 'DatabaseName']</b>
						</TD>
					</TR>
		
					[Inline:
						-database='LassoUsers',
						'DatabaseName'=(field: 'DatabaseName', EncodeNone),
						'UserName'='*',
						-search]
						<TR>
							<TD bgcolor="#cccccc">
								User Name
							</TD>
							<TD bgcolor="#cccccc">
								Password
							</TD>
							<TD bgcolor="#cccccc">
								Permissions
							</TD>
						</TR>
						[records]
							<TR>
								<TD BGCOLOR="#FFFFFF">
									<A HREF="security.lasso?-database=LassoUsers&-response=Update_User.html&-recID=[field: 
										'ID']&DatabaseName=[Database_Name, encodeURL]&-search">[field: 'UserName']</A>
								</TD>
								<TD BGCOLOR="#FFFFFF">
									[if: (string_uppercase: (field: 'UserName')) == 'ALL USERS']
										<FONT COLOR="gray">N/A</FONT>
									[else: if: (field:'Password') == '']
										<FONT COLOR="red">&lt;None&gt;</FONT>
									[else]
										***********
									[/if]
								</TD>
								<TD BGCOLOR="#FFFFFF">
									<TABLE>
									<TR>
									[value_list: 'Permissions']
										<TD>
											[valuelistitem: checked]
										</TD>
									[/value_list]
									</TR>
									</TABLE>
								</TD>
							</TR>
						[/records]
					[/Inline]
				[/if]
			[/records]
		[/inline]
		</TABLE>
	</TD>
	</TR>
	</TABLE>
	
</BODY>
</HTML>
